Editing Nonclustered Index Filter

To create a filtered index, specify which rows to include in the index.

Note: Support from SQL Server 2008 or later and SQL Azure.

Example:

StartDate > '20040101' AND EndDate <= '20040630'